UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g6q4icHT7wt8FJahxXjXmSsonm5JLX9icRDrKGsB9WA='
WHERE
key_id = '207be85cfc1aa5f8344d11cc62a5bd04dd0388cb3465b572df3e4fb6bb842f1d'
AND (
token = 'g6q4icHT7wt8FJahxXjXmSsonm5JLX9icRDrKGsB9WA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)