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