UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CBTo83+0NXT88N8TEANAs+8onUDYQ3rM8C8JlWw3Wu8='
WHERE
key_id = 'f379c79b67c3562f5c2c00169a7ef0d8c8a073a0e547468fb6597babc6aded66'
AND (
token = 'CBTo83+0NXT88N8TEANAs+8onUDYQ3rM8C8JlWw3Wu8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)