UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4/Lu3EmB5xubgiS0jTKZqYWVePph6WbcXYe3J3a9+yg='
WHERE
key_id = '1471ba27734835b5abb655fc3feb05176001e2dd903e49aab64d1e8dbd175b5b'
AND (
token = '4/Lu3EmB5xubgiS0jTKZqYWVePph6WbcXYe3J3a9+yg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)