UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '34CW4xUceHcOVhUOXuUOhpdKmA6xgQZOG1HNrpC1pOw='
WHERE
key_id = '80c2333a4de8ee2b2114d67294ced69177ec61404a6389089a7ec36f4dc1aed9'
AND (
token = '34CW4xUceHcOVhUOXuUOhpdKmA6xgQZOG1HNrpC1pOw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)