UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SKrmMeUXx7uUYb5dzbaUMAI30+bFCIiE7G/MzmmRsng='
WHERE
key_id = '9eec7d9605dfc589e6ccef6802351fa24a311592a4b756738c43ed45961d9b18'
AND (
token = 'SKrmMeUXx7uUYb5dzbaUMAI30+bFCIiE7G/MzmmRsng='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)