SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '8cb1c8a493dc7e72b33672fa55f78ba0fbe8812c39241b9c4190fa411ec52ca5' 
  AND token = 'EBc4PqoHNOSPULcv58971pf6rY/ygq0+CtALI7uM2Ug=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00035

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}