UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8zdf0B8K1mM1KVVr8oDFFkYwsRJA8NnGa0E8S+sZoOc='
WHERE
key_id = '586c45080cf1a668ff61329558e5e7d120f07eb9406f8ff3e6b91a8050439a76'
AND (
token = '8zdf0B8K1mM1KVVr8oDFFkYwsRJA8NnGa0E8S+sZoOc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)