UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D6hScRv1Kub8psgjLcnBUFm2CvIPMLtTOXcJvT6iAb4='
WHERE
key_id = '439e86906d647708fe7e56d749587ab2bc2d3f3463b35e0275a4793b80c47194'
AND (
token = 'D6hScRv1Kub8psgjLcnBUFm2CvIPMLtTOXcJvT6iAb4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)