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