SELECT 
  1 
FROM 
  cscart_aprillock_keys 
WHERE 
  key_id = 'bd31ba56094825a600e8a61e29625f23d306a3ee2053c9a242160aebca9a253b' 
  AND token = 'p0Djt+OasuGRgArfzWKO2ks+hjlHsm6TV1VnYaym00E=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00028

JSON explain

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