UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U+RnzEmgt5tGDB5y6AAkbJuMGFBuoVUzrVALiqNqSoU='
WHERE
key_id = '25b540c991aebc19f828d90097781a4831170ac5f59490e5b8954f011450625b'
AND (
token = 'U+RnzEmgt5tGDB5y6AAkbJuMGFBuoVUzrVALiqNqSoU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)