UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8oFMbRl+rP4asEcausxTw96ACPOgNU0jwIBZZF0vGXQ='
WHERE
key_id = '42dd27119d0316f7d2b07be4ca0a4168c6b2b516c2cd65ef815e55ae2e983bf5'
AND (
token = '8oFMbRl+rP4asEcausxTw96ACPOgNU0jwIBZZF0vGXQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)