UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8AKlE7GmBJHsc29tlkDbrsK/ffA9g5qTwKA8COIqA58='
WHERE
key_id = '2b45f6916222bafe0157f0c79dc7d820ae376b22251290e8aeaf7a1291b64895'
AND (
token = '8AKlE7GmBJHsc29tlkDbrsK/ffA9g5qTwKA8COIqA58='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)