SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '1d6325115165fc4dc7fff430b03df677d16b094a9615cc5ae38d7c7247be5c1d' 
  AND token = 'LmlW7uiXhTz186W0Ycon16taK11eRBI6Qe7VMrnyUng=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00038

JSON explain

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