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