UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9h/gYrCPStbyxu9Z3WaWUedYM/n83wJU7/PCn4b27bo='
WHERE
key_id = 'cdda4211d702d15be75a749ed16a5937dd7b3a0cf2d7a8765efc90ce252dc4a0'
AND (
token = '9h/gYrCPStbyxu9Z3WaWUedYM/n83wJU7/PCn4b27bo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)