SELECT 
  1 
FROM 
  cscart_aprillock_keys 
WHERE 
  key_id = 'd92cd4ea8e6b32327033e0395a6b2c89a8db92c19a6f50c4a40bb79a56d49c4c' 
  AND token = 'joSIOj/S9vavERa92Q/B9pv2hzH2SBtSUWaYIwVTBC8=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00036

JSON explain

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