SELECT 
  1 
FROM 
  cscart_aprillock_keys 
WHERE 
  key_id = '17652192312dcc76234f7e20f1105e728b63f5a59629ed71c2b9ededde9a6eff' 
  AND token = '4/iZN/meiyUBPzFdW6tBen8hQlUd+d8hBiiZYa0ZQdc=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00035

JSON explain

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