UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rm1L2MfD3PgwrF9edp3FSdcozMnslU6gEBxL7FcH3iQ='
WHERE
key_id = 'c31a1f5124830ea04879ebd2dbc66c6f50542aeb1bb4f5c2fddf7757c80fed8b'
AND (
token = 'rm1L2MfD3PgwrF9edp3FSdcozMnslU6gEBxL7FcH3iQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)