UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g7ztsWc4C44IhRkP/vtkACLsrp3orGnsQZ6Byr65tYg='
WHERE
key_id = 'd4e185d25a67cd59b1b6bb1c2c4d3894a06038f05717a0e22d0eb9cdb89bd1be'
AND (
token = 'g7ztsWc4C44IhRkP/vtkACLsrp3orGnsQZ6Byr65tYg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)