UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'opyQVCA1+6k7p76EGld6VF3NGinu/mkqsMYT9zcAh1Y='
WHERE
key_id = '8f9245c6b67e443acc6ca71426c23fa24efe5ca10222af2b7ffe2c37ae45081d'
AND (
token = 'opyQVCA1+6k7p76EGld6VF3NGinu/mkqsMYT9zcAh1Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)