UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Do7DT5s6X9bMgYFV2LUgymkf4ChCM3Zlnu7eJ1EgKyI='
WHERE
key_id = 'dc9b091740ce0e540082075a5bd4b37cb273507ab1a8fec8895b021cf8f9953b'
AND (
token = 'Do7DT5s6X9bMgYFV2LUgymkf4ChCM3Zlnu7eJ1EgKyI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)