UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6i6mQuWLPtu93UL0/1JymuuQJwRTnbZe2aq8KyVaDd8='
WHERE
key_id = 'bc931eabd6e9ea1f43145666dc472377e4a0e46cb9e18e7f8a65b71d7586536b'
AND (
token = '6i6mQuWLPtu93UL0/1JymuuQJwRTnbZe2aq8KyVaDd8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)