UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zPuky2/nIUu91tlz5Hs6ZxEJF84/ZOADhZRPiXZQoT0='
WHERE
key_id = '9690fa5ce83d517f98d2a6f1b622ce4af6d535e2b9bc5467702662a4b8f34fc8'
AND (
token = 'zPuky2/nIUu91tlz5Hs6ZxEJF84/ZOADhZRPiXZQoT0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)