UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Dy6pNU/ViWdHm95ARItDmENcr31pk8D1Xo/oHcotos='
WHERE
key_id = '669fccf32a29941365e6fd238b2f78c72401fcc5c0d1994f99233dc76ac8fb52'
AND (
token = '8Dy6pNU/ViWdHm95ARItDmENcr31pk8D1Xo/oHcotos='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)