SELECT 
  1 
FROM 
  cscart_aprillock_keys 
WHERE 
  key_id = '1bbe18791240aeccea0e630cd3a1aa07b62948838e66f59a76ee3ece70fc8700' 
  AND token = 'UQw5vU86T/KPapxHX6ilNms3XUeUXRtG0aqLzsO0WQU=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00031

JSON explain

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