UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gK0pSIjBHjUNOT2GVmjDNjJkS8zbF0qImLzkhcvY3vU='
WHERE
key_id = '944025c734d558ac71ed6cd303fae4d102dbc0e3ddbb32b36443c78740291e52'
AND (
token = 'gK0pSIjBHjUNOT2GVmjDNjJkS8zbF0qImLzkhcvY3vU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)