UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SYgEls6yXvj98GmXgDutk0pMhLsUyg8J1V89/U8B1s0='
WHERE
key_id = 'c43f12f0442c46266e4ff8de4fdb71cb81ec6b194eff2c7e64d1cee5c18e1937'
AND (
token = 'SYgEls6yXvj98GmXgDutk0pMhLsUyg8J1V89/U8B1s0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)