SELECT 
  1 
FROM 
  cscart_aprillock_keys 
WHERE 
  key_id = '2abce364b3f3a2d98b4d9b8a3c2be4ca82c1ea12d3dd16b731701b75f0daafec' 
  AND token = 'hLv0O0KUnqJfjwoi0bTZqQ28p4mO2jX63XDixD8A5Y0=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00020

JSON explain

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