SELECT 
  1 
FROM 
  cscart_aprillock_keys 
WHERE 
  key_id = '331ae7ef28ca6b7033b3b809c8b3f213d171414785a6c5c9ae4e291d04fe0656' 
  AND token = 'N3A90JYF7rHhn5tQadzdG+D4mTB1U7ADWWOiSaMZ3XE=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00036

JSON explain

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