UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h6QBaKyoWglYLcUSD/whpz7WLYXGQcURSk4cWpN9uWU='
WHERE
key_id = 'b95194034748d53a6d66f875d57cd4ec901de08180956896e85292969056570c'
AND (
token = 'h6QBaKyoWglYLcUSD/whpz7WLYXGQcURSk4cWpN9uWU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)