SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '9f5f97219ce65e0bd301b6517a8591a89c085bac44528bf585e04c287c36ab99' 
  AND token = 'aP6IJ/Y3irFNN/nRN8sGpXSj6An2/wz+Ay5eY+u/jMc=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00019

JSON explain

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