UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mscOkpU1Qd69W9lF+qwQ1Npj6KtSAE2nP3c/4vuD72Y='
WHERE
key_id = '97c29e1ebfec164d7925f0c67f7fad5dbbfca85abfcb9df2016d0a6551ef40b8'
AND (
token = 'mscOkpU1Qd69W9lF+qwQ1Npj6KtSAE2nP3c/4vuD72Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)