SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '8697d627691bab92f40e0d9f3a485cd9c936c8633a87332b8e2a2f89412c238f' 
  AND token = 'IRXRZLE3JLUDWana2dXPRT13cP9ZKwS/1Kmr+7YHLQM=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00045

JSON explain

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