UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QBngTUCHa0u0y74g5z1G8t5rTPVE9j27ykYAsD8qPpE='
WHERE
key_id = 'd01c461b216cd021aa2b186b88b6ae990e0d66f78781b009325ac21657069f52'
AND (
token = 'QBngTUCHa0u0y74g5z1G8t5rTPVE9j27ykYAsD8qPpE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)