UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2OasFyAwvx6dnmyUvkZFHATW0bmpIjRyH8REurLvXBs='
WHERE
key_id = '1e1bcb3e680e6fe49425e9cc55e9ea5800e24385cc972b684616868081a7ef55'
AND (
token = '2OasFyAwvx6dnmyUvkZFHATW0bmpIjRyH8REurLvXBs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)