UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3XWaZsylIwiYMO2YRIv47TCNGn9jg8uHYHSa0uTIwLo='
WHERE
key_id = '9f25a79e584d4fc26c7f4a2ff491832d64109ce08ccc53657e5b7e4fad340fd1'
AND (
token = '3XWaZsylIwiYMO2YRIv47TCNGn9jg8uHYHSa0uTIwLo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)