SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'b07bbea18c3d83b50d9de7059f063a5c635d3d46371bfb17a47260905f2055b0' 
  AND token = 'BVv+a3Yl8BT1K88Ydhx+wdQVTQt0/BwrHFetv3Ldsg0=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00009

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}