UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sjCjBkJ/L/NRxttnWZkpgVEkwRDBUZ5UdIM5ezAUZZ0='
WHERE
key_id = '99e3ad232a06a4fe0aeb565d5cd0265bee475a0a0ca2f8ff3cea71d68ec64cd7'
AND (
token = 'sjCjBkJ/L/NRxttnWZkpgVEkwRDBUZ5UdIM5ezAUZZ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)