UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9M2KnNnsubCGTNI2S/ygXb8jQQ2Ie7J5rhPU1K8Nz2o='
WHERE
key_id = 'db9a3caef011ab2101b2e15ff4943c088515c1a4a9b992b9a3fe8892edbf4bf6'
AND (
token = '9M2KnNnsubCGTNI2S/ygXb8jQQ2Ie7J5rhPU1K8Nz2o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)