UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sx+nLSZbL7ondePWcFwXRDeYC3BQbHEOWSqTBpariq8='
WHERE
key_id = 'a9aed6e25cf2bbd30f3401975eb2e47b04803f90f79c238b077ea9e424cb477b'
AND (
token = 'sx+nLSZbL7ondePWcFwXRDeYC3BQbHEOWSqTBpariq8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)