UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q1cLo+Kzz9iHQtyObKJtEV3pCw1wQIFmIk3ZtEJQtrQ='
WHERE
key_id = 'effa27333b3ea9345f555cd55638820c48f1d95df24a7f1002c5d0c639b1e309'
AND (
token = 'Q1cLo+Kzz9iHQtyObKJtEV3pCw1wQIFmIk3ZtEJQtrQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)