UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QdQe2hSEilRFE2aRm2zmpNbCQ7FSrCTvGLThTP7zeWY='
WHERE
key_id = 'caa9018b8741a87c03ba7bd5eced7a540689edd1798795287c3640bafd5b4244'
AND (
token = 'QdQe2hSEilRFE2aRm2zmpNbCQ7FSrCTvGLThTP7zeWY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)