UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dxkVWwIajJ0D8Bzi945042SETIJNkjacOqd9Fb+GYz8='
WHERE
key_id = 'e98df35dac991b36ab0a066a3038e305da029f812712a7b4afd2138c07de9bae'
AND (
token = 'dxkVWwIajJ0D8Bzi945042SETIJNkjacOqd9Fb+GYz8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)