SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '2f28dd36a6b51c376a48c8e3839dc4a3cba81da3fa389b185244579f72309a45' 
  AND token = 'prdqQi0XXN8f0gIVTmwOcc4k+hJd/6NSCw89jTmOFms=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00016

JSON explain

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