UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4XeH2lcFqhFjjLEcJwtxo6Aw0pm2mI3pLu3ArbUCByI='
WHERE
key_id = 'b3e4d25caf01afaa351e24da151077855ae6abcb39999b77f9cf814657561cf6'
AND (
token = '4XeH2lcFqhFjjLEcJwtxo6Aw0pm2mI3pLu3ArbUCByI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)