UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sxOrsGElX4li2vsxvshqnCP9tXzt0IS88yGCq2Sm7V0='
WHERE
key_id = '0842967dfdfa67826c06701c2c64f7586e04916d1a668aa76c42bf616a4661b1'
AND (
token = 'sxOrsGElX4li2vsxvshqnCP9tXzt0IS88yGCq2Sm7V0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)